package com.kehutong.charge.dao;

import com.kehutong.charge.dto.ChargeBillItemAppDTO;
import com.kehutong.charge.entity.ReceiptsStatistics;
import org.coraframework.orm.annotation.Dao;
import org.coraframework.orm.annotation.Mapper;
import org.coraframework.orm.jdbc.Page;
import org.coraframework.orm.jdbc.execute.Condition;

import java.util.HashMap;
import java.util.List;

@Dao
public interface ChargeOrderDao {


	@Mapper(
			genericType = ChargeBillItemAppDTO.class,
			countSQL = "SELECT count(1) FROM( select id FROM t_charge_order_item WHERE ${}) a",
			sql= "select communityNo,communityName,chargeName,residentsType,billAddress,orderYearMonth billYearMonth,sum(paymentAmount) payableAmount " +
					"from t_charge_order_item WHERE ${}"
	)
	Page<ChargeBillItemAppDTO> findOrderItemList(Condition... condition);

}
